﻿CREATE TABLE [dbo].[Leave] (
    [Id]     INT            IDENTITY (1, 1) NOT NULL,
    [Year]   NCHAR (4)      NOT NULL,
    [Month]  NCHAR (2)      NOT NULL,
    [Day]    NCHAR (2)      NOT NULL,
    [UserId] INT            NOT NULL,
    [Note]   NVARCHAR (100) NULL, 
    PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Leave_ToUser] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([Id]) ON DELETE CASCADE
);

